Dataset statistics
| Number of variables | 8 |
|---|---|
| Number of observations | 2035 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 127.3 KiB |
| Average record size in memory | 64.1 B |
Variable types
| DateTime | 1 |
|---|---|
| TimeSeries | 5 |
| Numeric | 2 |
Timeseries statistics
| Number of series | 5 |
|---|---|
| Time series length | 2035 |
| Starting point | 0 |
| Ending point | 2034 |
| Period | 1 |
Open is highly overall correlated with High and 5 other fields | High correlation |
High is highly overall correlated with Open and 5 other fields | High correlation |
Low is highly overall correlated with Open and 5 other fields | High correlation |
Last is highly overall correlated with Open and 5 other fields | High correlation |
Close is highly overall correlated with Open and 5 other fields | High correlation |
Total Trade Quantity is highly overall correlated with Open and 5 other fields | High correlation |
Turnover (Lacs) is highly overall correlated with Open and 5 other fields | High correlation |
Open is non stationary | Non stationary |
High is non stationary | Non stationary |
Low is non stationary | Non stationary |
Last is non stationary | Non stationary |
Close is non stationary | Non stationary |
Open is seasonal | Seasonal |
High is seasonal | Seasonal |
Low is seasonal | Seasonal |
Last is seasonal | Seasonal |
Close is seasonal | Seasonal |
Date has unique values | Unique |
Reproduction
| Analysis started | 2023-08-23 10:47:33.351791 |
|---|---|
| Analysis finished | 2023-08-23 10:47:40.201735 |
| Duration | 6.85 seconds |
| Software version | ydata-profiling vv4.5.1 |
| Download configuration | config.json |
Date
Date
UNIQUE 
| Distinct | 2035 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 16.0 KiB |
| Minimum | 2010-07-21 00:00:00 |
|---|---|
| Maximum | 2018-09-28 00:00:00 |
Open
Numeric time series
HIGH CORRELATION  NON STATIONARY  SEASONAL 
| Distinct | 1165 |
|---|---|
| Distinct (%) | 57.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 149.71373 |
|---|---|
| Minimum | 81.1 |
| Maximum | 327.7 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 16.0 KiB |
Quantile statistics
| Minimum | 81.1 |
|---|---|
| 5-th percentile | 92.22 |
| Q1 | 120.025 |
| median | 141.5 |
| Q3 | 157.175 |
| 95-th percentile | 273.255 |
| Maximum | 327.7 |
| Range | 246.6 |
| Interquartile range (IQR) | 37.15 |
Descriptive statistics
| Standard deviation | 48.664509 |
|---|---|
| Coefficient of variation (CV) | 0.3250504 |
| Kurtosis | 2.240073 |
| Mean | 149.71373 |
| Median Absolute Deviation (MAD) | 18.5 |
| Skewness | 1.5838736 |
| Sum | 304667.45 |
| Variance | 2368.2345 |
| Monotonicity | Not monotonic |
| Augmented Dickey-Fuller test p-value | 0.3378405913 |
Gap statistics
| number of gaps | 0 |
|---|---|
| min | nan |
| max | nan |
| mean | nan |
| std | 0 |
| Value | Count | Frequency (%) |
| 148 | 12 | 0.6% |
| 120 | 10 | 0.5% |
| 157 | 9 | 0.4% |
| 142 | 9 | 0.4% |
| 155 | 9 | 0.4% |
| 116 | 8 | 0.4% |
| 143 | 8 | 0.4% |
| 151 | 8 | 0.4% |
| 110 | 7 | 0.3% |
| 132 | 7 | 0.3% |
| Other values (1155) | 1948 |
| Value | Count | Frequency (%) |
| 81.1 | 1 | |
| 82.1 | 1 | |
| 82.2 | 1 | |
| 82.25 | 1 | |
| 82.4 | 1 | |
| 82.5 | 1 | |
| 82.55 | 1 | |
| 82.6 | 1 | |
| 83.2 | 1 | |
| 83.5 | 1 |
| Value | Count | Frequency (%) |
| 327.7 | 1 | |
| 323 | 1 | |
| 317.75 | 1 | |
| 317.6 | 1 | |
| 315.05 | 2 | |
| 315 | 1 | |
| 314.65 | 1 | |
| 314.3 | 1 | |
| 314 | 1 | |
| 313.85 | 1 |
High
Numeric time series
HIGH CORRELATION  NON STATIONARY  SEASONAL 
| Distinct | 1257 |
|---|---|
| Distinct (%) | 61.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 151.99283 |
|---|---|
| Minimum | 82.8 |
| Maximum | 328.75 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 16.0 KiB |
Quantile statistics
| Minimum | 82.8 |
|---|---|
| 5-th percentile | 93.97 |
| Q1 | 122.1 |
| median | 143.4 |
| Q3 | 159.4 |
| 95-th percentile | 276.915 |
| Maximum | 328.75 |
| Range | 245.95 |
| Interquartile range (IQR) | 37.3 |
Descriptive statistics
| Standard deviation | 49.413109 |
|---|---|
| Coefficient of variation (CV) | 0.32510159 |
| Kurtosis | 2.2121497 |
| Mean | 151.99283 |
| Median Absolute Deviation (MAD) | 18.8 |
| Skewness | 1.5864145 |
| Sum | 309305.4 |
| Variance | 2441.6554 |
| Monotonicity | Not monotonic |
| Augmented Dickey-Fuller test p-value | 0.3095187068 |
Gap statistics
| number of gaps | 0 |
|---|---|
| min | nan |
| max | nan |
| mean | nan |
| std | 0 |
| Value | Count | Frequency (%) |
| 135 | 14 | 0.7% |
| 121 | 9 | 0.4% |
| 119.8 | 8 | 0.4% |
| 125 | 8 | 0.4% |
| 154.5 | 7 | 0.3% |
| 143 | 7 | 0.3% |
| 148 | 7 | 0.3% |
| 156.5 | 7 | 0.3% |
| 147.5 | 6 | 0.3% |
| 144 | 6 | 0.3% |
| Other values (1247) | 1956 |
| Value | Count | Frequency (%) |
| 82.8 | 1 | |
| 83 | 1 | |
| 83.4 | 1 | |
| 83.45 | 1 | |
| 83.5 | 1 | |
| 83.7 | 1 | |
| 83.75 | 1 | |
| 83.85 | 1 | |
| 84.3 | 1 | |
| 84.85 | 1 |
| Value | Count | Frequency (%) |
| 328.75 | 1 | |
| 328.35 | 1 | |
| 326.9 | 1 | |
| 319.65 | 1 | |
| 319.2 | 1 | |
| 319.1 | 1 | |
| 318 | 1 | |
| 317.8 | 1 | |
| 317 | 1 | |
| 316.7 | 1 |
Low
Numeric time series
HIGH CORRELATION  NON STATIONARY  SEASONAL 
| Distinct | 1263 |
|---|---|
| Distinct (%) | 62.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 147.29393 |
|---|---|
| Minimum | 80 |
| Maximum | 321.65 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 16.0 KiB |
Quantile statistics
| Minimum | 80 |
|---|---|
| 5-th percentile | 90.855 |
| Q1 | 118.3 |
| median | 139.6 |
| Q3 | 155.15 |
| 95-th percentile | 267.885 |
| Maximum | 321.65 |
| Range | 241.65 |
| Interquartile range (IQR) | 36.85 |
Descriptive statistics
| Standard deviation | 47.931958 |
|---|---|
| Coefficient of variation (CV) | 0.32541706 |
| Kurtosis | 2.2269384 |
| Mean | 147.29393 |
| Median Absolute Deviation (MAD) | 18.15 |
| Skewness | 1.5735418 |
| Sum | 299743.15 |
| Variance | 2297.4726 |
| Monotonicity | Not monotonic |
| Augmented Dickey-Fuller test p-value | 0.3978208064 |
Gap statistics
| number of gaps | 0 |
|---|---|
| min | nan |
| max | nan |
| mean | nan |
| std | 0 |
| Value | Count | Frequency (%) |
| 141 | 11 | 0.5% |
| 115 | 7 | 0.3% |
| 152.5 | 7 | 0.3% |
| 119 | 7 | 0.3% |
| 151 | 7 | 0.3% |
| 117 | 6 | 0.3% |
| 127 | 6 | 0.3% |
| 112 | 6 | 0.3% |
| 157.7 | 6 | 0.3% |
| 116.1 | 5 | 0.2% |
| Other values (1253) | 1967 |
| Value | Count | Frequency (%) |
| 80 | 1 | |
| 80.3 | 1 | |
| 80.5 | 1 | |
| 81 | 1 | |
| 81.1 | 1 | |
| 81.2 | 2 | |
| 81.3 | 1 | |
| 81.55 | 1 | |
| 82.1 | 1 | |
| 82.25 | 1 |
| Value | Count | Frequency (%) |
| 321.65 | 1 | |
| 315 | 1 | |
| 314 | 1 | |
| 312.55 | 1 | |
| 312.2 | 1 | |
| 311.8 | 2 | |
| 311.45 | 1 | |
| 310.35 | 1 | |
| 310.15 | 1 | |
| 307.55 | 2 |
Last
Numeric time series
HIGH CORRELATION  NON STATIONARY  SEASONAL 
| Distinct | 1268 |
|---|---|
| Distinct (%) | 62.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 149.47425 |
|---|---|
| Minimum | 81 |
| Maximum | 325.95 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 16.0 KiB |
Quantile statistics
| Minimum | 81 |
|---|---|
| 5-th percentile | 92 |
| Q1 | 120.075 |
| median | 141.1 |
| Q3 | 156.925 |
| 95-th percentile | 273.255 |
| Maximum | 325.95 |
| Range | 244.95 |
| Interquartile range (IQR) | 36.85 |
Descriptive statistics
| Standard deviation | 48.73257 |
|---|---|
| Coefficient of variation (CV) | 0.32602652 |
| Kurtosis | 2.2287442 |
| Mean | 149.47425 |
| Median Absolute Deviation (MAD) | 18.45 |
| Skewness | 1.5848137 |
| Sum | 304180.1 |
| Variance | 2374.8634 |
| Monotonicity | Not monotonic |
| Augmented Dickey-Fuller test p-value | 0.412917482 |
Gap statistics
| number of gaps | 0 |
|---|---|
| min | nan |
| max | nan |
| mean | nan |
| std | 0 |
| Value | Count | Frequency (%) |
| 154.2 | 7 | 0.3% |
| 115.8 | 6 | 0.3% |
| 141.1 | 6 | 0.3% |
| 150 | 6 | 0.3% |
| 148 | 6 | 0.3% |
| 153 | 6 | 0.3% |
| 155.5 | 6 | 0.3% |
| 149 | 6 | 0.3% |
| 120.75 | 5 | 0.2% |
| 96 | 5 | 0.2% |
| Other values (1258) | 1976 |
| Value | Count | Frequency (%) |
| 81 | 1 | |
| 81.1 | 1 | |
| 81.6 | 1 | |
| 82.2 | 1 | |
| 82.4 | 1 | |
| 82.6 | 1 | |
| 82.75 | 1 | |
| 83.05 | 1 | |
| 83.4 | 1 | |
| 83.45 | 1 |
| Value | Count | Frequency (%) |
| 325.95 | 1 | |
| 323.7 | 1 | |
| 317.6 | 1 | |
| 317.45 | 1 | |
| 316.05 | 1 | |
| 314.7 | 1 | |
| 314.25 | 1 | |
| 314.05 | 1 | |
| 313.45 | 1 | |
| 313.1 | 1 |
Close
Numeric time series
HIGH CORRELATION  NON STATIONARY  SEASONAL 
| Distinct | 1313 |
|---|---|
| Distinct (%) | 64.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 149.45027 |
|---|---|
| Minimum | 80.95 |
| Maximum | 325.75 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 16.0 KiB |
Quantile statistics
| Minimum | 80.95 |
|---|---|
| 5-th percentile | 92.15 |
| Q1 | 120.05 |
| median | 141.25 |
| Q3 | 156.9 |
| 95-th percentile | 273.225 |
| Maximum | 325.75 |
| Range | 244.8 |
| Interquartile range (IQR) | 36.85 |
Descriptive statistics
| Standard deviation | 48.71204 |
|---|---|
| Coefficient of variation (CV) | 0.32594147 |
| Kurtosis | 2.2257142 |
| Mean | 149.45027 |
| Median Absolute Deviation (MAD) | 18.45 |
| Skewness | 1.5832241 |
| Sum | 304131.3 |
| Variance | 2372.8629 |
| Monotonicity | Not monotonic |
| Augmented Dickey-Fuller test p-value | 0.4115963869 |
Gap statistics
| number of gaps | 0 |
|---|---|
| min | nan |
| max | nan |
| mean | nan |
| std | 0 |
| Value | Count | Frequency (%) |
| 155.55 | 6 | 0.3% |
| 154.85 | 6 | 0.3% |
| 141.9 | 6 | 0.3% |
| 147.65 | 5 | 0.2% |
| 140.8 | 5 | 0.2% |
| 153.1 | 5 | 0.2% |
| 147.5 | 5 | 0.2% |
| 150.2 | 5 | 0.2% |
| 132.6 | 5 | 0.2% |
| 145.15 | 5 | 0.2% |
| Other values (1303) | 1982 |
| Value | Count | Frequency (%) |
| 80.95 | 1 | |
| 81.1 | 1 | |
| 81.55 | 1 | |
| 82 | 1 | |
| 82.4 | 1 | |
| 82.5 | 1 | |
| 82.55 | 1 | |
| 82.6 | 1 | |
| 82.7 | 1 | |
| 82.9 | 1 |
| Value | Count | Frequency (%) |
| 325.75 | 1 | |
| 323 | 1 | |
| 317.6 | 1 | |
| 316.4 | 2 | |
| 315.3 | 1 | |
| 314.1 | 1 | |
| 313.55 | 1 | |
| 313.3 | 1 | |
| 312.95 | 1 | |
| 312.9 | 1 |
Total Trade Quantity
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 2034 |
|---|---|
| Distinct (%) | > 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2335681.4 |
| Minimum | 39610 |
|---|---|
| Maximum | 29191015 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 16.0 KiB |
Quantile statistics
| Minimum | 39610 |
|---|---|
| 5-th percentile | 555214.1 |
| Q1 | 1146444.5 |
| median | 1783456 |
| Q3 | 2813594 |
| 95-th percentile | 6312189.1 |
| Maximum | 29191015 |
| Range | 29151405 |
| Interquartile range (IQR) | 1667149.5 |
Descriptive statistics
| Standard deviation | 2091778.1 |
|---|---|
| Coefficient of variation (CV) | 0.89557511 |
| Kurtosis | 24.055902 |
| Mean | 2335681.4 |
| Median Absolute Deviation (MAD) | 739863 |
| Skewness | 3.644369 |
| Sum | 4.7531117 × 109 |
| Variance | 4.3755357 × 1012 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 839802 | 2 | 0.1% |
| 3069914 | 1 | < 0.1% |
| 1762110 | 1 | < 0.1% |
| 3195668 | 1 | < 0.1% |
| 2640664 | 1 | < 0.1% |
| 2807473 | 1 | < 0.1% |
| 1442967 | 1 | < 0.1% |
| 3225051 | 1 | < 0.1% |
| 1828953 | 1 | < 0.1% |
| 2963777 | 1 | < 0.1% |
| Other values (2024) | 2024 |
| Value | Count | Frequency (%) |
| 39610 | 1 | |
| 100180 | 1 | |
| 108287 | 1 | |
| 111115 | 1 | |
| 125170 | 1 | |
| 163605 | 1 | |
| 169762 | 1 | |
| 193726 | 1 | |
| 207063 | 1 | |
| 210300 | 1 |
| Value | Count | Frequency (%) |
| 29191015 | 1 | |
| 17917625 | 1 | |
| 17805319 | 1 | |
| 17064363 | 1 | |
| 16822847 | 1 | |
| 15847309 | 1 | |
| 15744338 | 1 | |
| 14490021 | 1 | |
| 14484043 | 1 | |
| 13953152 | 1 |
Turnover (Lacs)
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 2030 |
|---|---|
| Distinct (%) | 99.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3899.9806 |
| Minimum | 37.04 |
|---|---|
| Maximum | 55755.08 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 16.0 KiB |
Quantile statistics
| Minimum | 37.04 |
|---|---|
| 5-th percentile | 595.585 |
| Q1 | 1427.46 |
| median | 2512.03 |
| Q3 | 4539.015 |
| 95-th percentile | 12101.592 |
| Maximum | 55755.08 |
| Range | 55718.04 |
| Interquartile range (IQR) | 3111.555 |
Descriptive statistics
| Standard deviation | 4570.7679 |
|---|---|
| Coefficient of variation (CV) | 1.1719976 |
| Kurtosis | 26.067865 |
| Mean | 3899.9806 |
| Median Absolute Deviation (MAD) | 1332.16 |
| Skewness | 4.0582341 |
| Sum | 7936460.4 |
| Variance | 20891919 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2140.22 | 2 | 0.1% |
| 2195.84 | 2 | 0.1% |
| 637.58 | 2 | 0.1% |
| 1047.42 | 2 | 0.1% |
| 1646.87 | 2 | 0.1% |
| 4082.77 | 1 | < 0.1% |
| 2015.28 | 1 | < 0.1% |
| 2261.37 | 1 | < 0.1% |
| 2400.63 | 1 | < 0.1% |
| 3732.17 | 1 | < 0.1% |
| Other values (2020) | 2020 |
| Value | Count | Frequency (%) |
| 37.04 | 1 | |
| 128.04 | 1 | |
| 129.09 | 1 | |
| 147.9 | 1 | |
| 163.11 | 1 | |
| 179.78 | 1 | |
| 186.62 | 1 | |
| 200.97 | 1 | |
| 206.87 | 1 | |
| 216.49 | 1 |
| Value | Count | Frequency (%) |
| 55755.08 | 1 | |
| 46643.39 | 1 | |
| 44321.86 | 1 | |
| 43913.37 | 1 | |
| 37901.49 | 1 | |
| 36047.39 | 1 | |
| 33327.37 | 1 | |
| 32325.56 | 1 | |
| 32227.87 | 1 | |
| 31569.51 | 1 |
| Open | High | Low | Last | Close | Total Trade Quantity | Turnover (Lacs) | |
|---|---|---|---|---|---|---|---|
| Open | 1.000 | 0.998 | 0.997 | 0.995 | 0.995 | 0.544 | 0.728 |
| High | 0.998 | 1.000 | 0.997 | 0.998 | 0.998 | 0.565 | 0.746 |
| Low | 0.997 | 0.997 | 1.000 | 0.998 | 0.998 | 0.534 | 0.720 |
| Last | 0.995 | 0.998 | 0.998 | 1.000 | 1.000 | 0.554 | 0.737 |
| Close | 0.995 | 0.998 | 0.998 | 1.000 | 1.000 | 0.554 | 0.737 |
| Total Trade Quantity | 0.544 | 0.565 | 0.534 | 0.554 | 0.554 | 1.000 | 0.962 |
| Turnover (Lacs) | 0.728 | 0.746 | 0.720 | 0.737 | 0.737 | 0.962 | 1.000 |
| Date | Open | High | Low | Last | Close | Total Trade Quantity | Turnover (Lacs) | |
|---|---|---|---|---|---|---|---|---|
| 0 | 2018-09-28 | 234.05 | 235.95 | 230.20 | 233.50 | 233.75 | 3069914 | 7162.35 |
| 1 | 2018-09-27 | 234.55 | 236.80 | 231.10 | 233.80 | 233.25 | 5082859 | 11859.95 |
| 2 | 2018-09-26 | 240.00 | 240.00 | 232.50 | 235.00 | 234.25 | 2240909 | 5248.60 |
| 3 | 2018-09-25 | 233.30 | 236.75 | 232.00 | 236.25 | 236.10 | 2349368 | 5503.90 |
| 4 | 2018-09-24 | 233.55 | 239.20 | 230.75 | 234.00 | 233.30 | 3423509 | 7999.55 |
| 5 | 2018-09-21 | 235.00 | 237.00 | 227.95 | 233.75 | 234.60 | 5395319 | 12589.59 |
| 6 | 2018-09-19 | 235.95 | 237.20 | 233.45 | 234.60 | 234.90 | 1362058 | 3202.78 |
| 7 | 2018-09-18 | 237.90 | 239.25 | 233.50 | 235.50 | 235.05 | 2614794 | 6163.70 |
| 8 | 2018-09-17 | 233.15 | 238.00 | 230.25 | 236.40 | 236.60 | 3170894 | 7445.41 |
| 9 | 2018-09-14 | 223.45 | 236.70 | 223.30 | 234.00 | 233.95 | 6377909 | 14784.50 |
| Date | Open | High | Low | Last | Close | Total Trade Quantity | Turnover (Lacs) | |
|---|---|---|---|---|---|---|---|---|
| 2025 | 2010-08-03 | 118.3 | 119.95 | 117.90 | 118.65 | 118.30 | 611234 | 726.78 |
| 2026 | 2010-08-02 | 117.3 | 118.50 | 116.60 | 118.10 | 117.30 | 663593 | 779.85 |
| 2027 | 2010-07-30 | 116.5 | 118.00 | 114.60 | 115.85 | 116.05 | 2656191 | 3112.68 |
| 2028 | 2010-07-29 | 112.5 | 121.70 | 112.50 | 117.50 | 116.60 | 2359134 | 2791.03 |
| 2029 | 2010-07-28 | 118.0 | 120.50 | 117.20 | 118.15 | 118.25 | 835593 | 994.01 |
| 2030 | 2010-07-27 | 117.6 | 119.50 | 112.00 | 118.80 | 118.65 | 586100 | 694.98 |
| 2031 | 2010-07-26 | 120.1 | 121.00 | 117.10 | 117.10 | 117.60 | 658440 | 780.01 |
| 2032 | 2010-07-23 | 121.8 | 121.95 | 120.25 | 120.35 | 120.65 | 281312 | 340.31 |
| 2033 | 2010-07-22 | 120.3 | 122.00 | 120.25 | 120.75 | 120.90 | 293312 | 355.17 |
| 2034 | 2010-07-21 | 122.1 | 123.00 | 121.05 | 121.10 | 121.55 | 658666 | 803.56 |